Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 include("connect.php");
3 include('anaysispage.php');
4 ?>
5 <!--*****************Analysis data*****************************-->
6 <?php
7 SESSION_START();
8 ?>
9
10 <!DOCTYPE html>
11 <html>
12
13 <head>
14 <meta charset="utf-8">
15 <meta name="viewport" content="width=device-width, initial-scale=1.0">
16 <title>school management system</title>
17 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
18 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
19 <link href="assets/css/loader.css" rel="stylesheet" />
20 <script src="assets/js/canvasjs.min.js"></script>
21 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
22 <script src="assets/js/jquery-3.2.1.js"></script>
23
24 <script type="text/javascript">
25 var class1=<?php echo $class1; ?>;
26 var class2=<?php echo $class2; ?>;
27 var class3=<?php echo $class3; ?>;
28 var class4=<?php echo $class4; ?>;
29 var class5=<?php echo $class5; ?>;
30 var class6=<?php echo $class6; ?>;
31 var class7=<?php echo $class7; ?>;
32 var class8=<?php echo $class8; ?>;
33 window.onload = function () {
34 var chart = new CanvasJS.Chart("chartContainer", {
35 title:{
36 text: "Number of students"
37
38 },
39 data: [
40 {
41 // Change type to "doughnut", "line", "splineArea", etc.
42 type: "spline",
43
44 dataPoints: [
45 { label: "Form 1", y: class1 },
46 { label: "Form 2", y: class2 },
47 { label: "Form 3", y: class3 },
48 { label: "Form 4", y: class4 },
49 ]
50 }
51 ]
52 });
53 chart.render();
54 }
55 </script>
56
57
58 </head>
59 <!--<style type="text/css">
60 body{
61 margin-right: 10px;
62 margin-left: 10px;
63 }
64 </style>
65
66 -->
67 <style type="text/css">
68 .panel-success{
69 background-color: rgba(245, 245, 245, 0);
70 border:none;
71 }
72
73 </style>
74
75
76
77 <body background="assets/img/5.jpg" >
78 <!--end of heading section-->
79 <ul class="nav navbar-right top-nav">
80 <div class="dropdown">
81 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
82 <?php
83 //Check to see if the user is logged in.if not redirect user to the loging page.
84
85 if(isset($_SESSION['fname']))
86 {
87 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
88 $adm=$_SESSION['role'];
89 }else{
90 echo "<script type='text/javascript'>
91 alert( 'You must Log in to use the system');
92 </script>";
93 echo "<script>
94 window.location = 'index.php'
95 </script>";
96 }
97 ?>
98 <span class="caret"></span></button>
99 <ul class="dropdown-menu">
100 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
101 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
102 <li class="divider"></li>
103 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
104 </ul>
105 </div>
106 </ul>
107 <!--************************************************-->
108 <div style="
109 font-family:Nyala, Arial;
110 text-align: left;
111 background-color: #526F35;
112 padding: 20px;
113 color:white;
114 width: 100%;
115 height: 150px;">
116 <!--This codes to load the image loader-->
117 <div id="loading">
118 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
119 </div>
120 <!--this is the heading section-->
121 <h2>
122 <?php
123 $sql="SELECT * FROM companyinfo";
124 $result=mysqli_query($db,$sql) or die("error getting data");
125 $num_rows=mysqli_num_rows($result);
126 while($row=mysqli_fetch_array($result))
127 {
128 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
129 $cname = $row['cname'];
130 $cemail = $row['cemail'];
131 $ccontact = $row['ccontact'];
132 $clocation = $row['clocation'];
133 }?>
134 <?php
135 echo $cname;
136 ?>
137
138 <div style="float:right; font-size:20px;text-align:right;">
139
140 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
141 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
142 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
143
144 </div>
145 </h2>
146 </div>
147 <div>
148 <ul class="nav nav-tabs">
149 <li class="active"><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
150 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
151 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
152 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
153 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
154 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
155 <li><a href="hostel.php" >Hostel[<i>Premium</i>] <img src="assets/img/details.png"></a></li>
156 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
157 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
158 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
159
160 </ul>
161 <div class="tab-content">
162 <div class="tab-pane active" role="tabpanel" id="tab-1">
163
164 <p>
165 <div class="table-responsive" >
166 <!--****************************************************************************-->
167
168
169
170
171 <!--*************************************************************************************************************************-->
172
173
174 <div ><h4>
175 <table class="table" style="text-align:center" >
176 <tr >
177
178 <td >
179 <div class="panel panel-success">
180 <div class="panel-heading">Students</div>
181 <div class="panel-body">
182
183 <font color="red">
184 <?php
185 $sql="SELECT * FROM studentstable";
186
187 $result=mysqli_query($db,$sql) or die("error getting data");
188 $num_rows=mysqli_num_rows($result);
189 echo "$num_rows Student[s] found</font><br>";
190 echo "<a href='viewstudentrecord.php'>View students";
191 echo "|| <br>";
192 echo "<a href='displine.php'>Record Displinary case </a>";
193 echo "||";
194 echo "<a href='m1.php'>Monitor student </a>";
195 ?><br>
196 <?php
197 $sql="SELECT * FROM studentstable WHERE gender='female'";
198 $result=mysqli_query($db,$sql) or die("error getting data");
199 $num_rows=mysqli_num_rows($result);
200 echo "$num_rows Female Students</font>";
201 ?>
202 <img src="assets/img/students.png">
203 <?php
204 $sql="SELECT * FROM studentstable WHERE gender='male'";
205 $result=mysqli_query($db,$sql) or die("error getting data");
206 $num_rows=mysqli_num_rows($result);
207 echo "$num_rows Male Students</font>";
208 ?>
209 </font>
210 <img src="assets/img/students.png">
211 </div>
212 </td>
213
214 <td>
215 <div class="panel panel-success" >
216 <div class="panel-heading">Staff/Office</div>
217 <div class="panel-body">
218 <a href="viewstaff.php" >View Staffs<br>
219 <a href="viewstaff.php" >Recomendation letter<br>
220
221 </div>
222 </td>
223 <td>
224 <div class="panel panel-success">
225 <div class="panel-heading">Communication</div>
226 <div class="panel-body">
227 <a href="sms.php" >Bulk sms<br><img src="assets/img/sms.png"></a><br>
228 <!--***when i click a link to get a confirmation wheathert to continue of not-->
229 <script type="text/javascript">
230 function AlertIt() {
231 var answer = confirm ("Please click on OK to continue.")
232 if (answer)
233 window.location="http://www.continue.com";
234 }
235 </script>
236 <!--***when i click a link to get a confirmation wheathert to continue of not-->
237 <!-- <a href="javascript:AlertIt();">Bulk Emails</a> -->
238 <a href="register_form.php">System Users<br><img src="assets/img/users.png"></a>
239 </div>
240 </td>
241 </tr>
242 <tr>
243 <td >
244 <div class="panel panel-success">
245 <div class="panel-heading">Accounting</div>
246 <div class="panel-body">
247 <?php
248 if ($_SESSION['role']!="adm"){
249 $error="This is a Premium module";
250 }else{
251 $password=$_SESSION['password'];
252 }
253 ?>
254
255 <!--issues with payment are sensitive and therefore need approaite approval before editing-->
256 <script>
257 function myFunction() {
258 var person =prompt("Please confirm your password");
259
260 if (person =="<?php echo $password; ?>") {
261 txt = "Welcome to the fee module";
262 window.location="feestudents.php";
263 } else {
264 var txt ="You are not allowed to access this module";
265 alert(txt);
266 }
267 }
268 </script>
269 <!--issues with payment are sensitive and therefore need approaite approval before editing-->
270 <a href="./fee.php">Accounts Management<img src="assets/img/fee.png"></a><br>
271
272 <a href="#">Expected fee</a><img src="assets/img/new.png"></a><br>
273 <a href="#">Expences</a><img src="assets/img/expence2.png"></a><br>
274
275 <!-- <a href="printfeeinvoice.php">Print Invoice<img src="assets/img/print2.png"></a>-->
276 </div>
277 </td>
278 <td>
279 <div class="panel panel-success">
280 <div class="panel-heading">Advanced Students management</div>
281 <div class="panel-body">
282
283 <script>
284 function myFunction2() {
285 var person = prompt("Please confirm your password");
286 if (person =="<?php echo $password; ?>") {
287 txt = "Welcome to the fee module";
288 window.location="#";
289 } else {
290 var txt ="You are not allowed to access this module";
291 alert(txt);
292 }
293 }
294 </script>[Premium]
295
296 <a href="javascript:myFunction2();">Promote/Dispute/Transfer student<br><img src="assets/img/promote.png"></a>
297 </div>
298 </td>
299 <td>
300 <div class="panel panel-success">
301 <div class="panel-heading">Parent/Guardians</div>
302 <div class="panel-body">
303 <a href="parents.php">View List<br></a>
304 </div>
305 </td>
306 </tr>
307 <tr>
308 <script>
309 function myFunction3() {
310 var person = prompt("Please confirm your password before accessing this module");
311 if (person =="<?php echo $password; ?>") {
312 txt = "Welcome to the fee module";
313 window.location="pro1.php";
314 } else {
315 var txt ="You are not allowed to access this module";
316 alert(txt);
317 }
318 }
319 </script>
320 <td>
321 <div class="panel panel-success">
322 <div class="panel-heading">Company Information</div>
323 <div class="panel-body">
324 <a href="./companyinfo.php" >Company Info<img src="assets/img/info.png"></a><br>
325 <!-- <a href="backup_tables.php" >Back Up database<img src="assets/img/backup.png"></a> -->
326 </div>
327 </td>
328 <td>
329 <div class="panel panel-success">
330 <div class="panel-heading">Inventory</div>
331 <div class="panel-body">
332 [Premium]
333 <a href="#">Inventory </a>
334 </div>
335 </td>
336
337 </tr>
338 </table></h4></div>
339
340 <!--*********************************************************************************-->
341
342 <div class="col-md-12" style="background-color:#526F35; position:fixed;bottom:0px;">
343 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
344 </div>
345
346
347 <script src="assets/js/jquery.min.js"></script>
348 <script src="assets/js/affix.js"></script>
349 <script src="assets/js/alert.js"></script>
350 <script src="assets/js/alert1.js"></script>
351 <script src="assets/js/bootstrap.js"></script>
352 <script src="assets/js/bootstrap.min.js"></script>
353 <script src="assets/js/bootstrap-datepicker.js"></script>
354 <script src="assets/js/bootstrap-wysihtml5.js"></script>
355 <script src="assets/js/button.js"></script>
356 <script src="assets/js/carousel.js"></script>
357 <script src="assets/js/chosen.jquery.min.js"></script>
358 <script src="assets/js/ckeditor.js"></script>
359 <script src="assets/js/collapse.js"></script>
360 <script src="assets/js/color.js"></script>
361 <script src="assets/js/dropdown.js"></script>
362 <script src="assets/js/DT_bootstrap.js"></script>
363 <script src="assets/js/dynamic.js"></script>
364 <script src="assets/js/ie-emulation-modes-warning.js"></script>
365 <script src="assets/js/jquery.dataTables.js"></script>
366 <script src="assets/js/jquery.dataTables.min.js"></script>
367 <script src="assets/js/jquery.dialog.js"></script>
368 <script src="assets/js/jquery.hoverdir.js"></script>
369 <script src="assets/js/jquery.jgrowl.js"></script>
370 <script src="assets/js/jquery.knob.js"></script>
371 <script src="assets/js/jquery.uniform.min.js"></script>
372 <script src="assets/js/jquery-1.8.3.min.js"></script>
373 <script src="assets/js/jquery-1.9.1.js"></script>
374 <script src="assets/js/jquery-1.9.1.min.js"></script>
375 <script src="assets/js/jquery-1.10.2.js"></script>
376 <script src="assets/js/jquery-1.11.0.js"></script>
377 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
378 <script src="assets/js/jquery-ui-1.10.3.js"></script>
379 <script src="assets/js/modal.js"></script>
380 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
381 <script src="assets/js/myjquery.js"></script>
382 <script src="assets/js/myjquery1.js"></script>
383 <script src="assets/js/npm.js"></script>
384 <script src="assets/js/popover.js"></script>
385 <script src="assets/js/profile.js"></script>
386 <script src="assets/js/raphael-min.js"></script>
387 <script src="assets/js/sb-admin-2.js"></script>
388 <script src="assets/js/scripts.js"></script>
389 <script src="assets/js/scrollspy.js"></script>
390 <script src="assets/js/tab.js"></script>
391 <script src="assets/js/tooltip.js"></script>
392 <script src="assets/js/transition.js"></script>
393 <script src="assets/js/wysihtml5-0.3.0.js"></script>
394 <script src="assets/js/slideshow.js"></script>
395
396 <script language="javascript" type="text/javascript">
397 $(window).load(function()
398 {
399 $('#loading').hide();
400 });
401 </script>
402
403 <script>
404 $(document).ready(function(){
405 $('.dropdown-submenu a.test').on("click", function(e){
406 $(this).next('ul').toggle();
407 e.stopPropagation();
408 e.preventDefault();
409 });
410 });
411 </script>
412 </body>
413
414 </html>